{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Présentation","Impression","Aide","Sauvegarde","Donnees_DDS"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Présentation","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Taille des fenêtres",0.8]

{"sheet":"Impression","index":1,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,0,6,4],[7,0,7,4],[8,0,8,4],[11,0,11,4],[13,0,13,4],[9,0,9,4],[10,0,10,4],[12,0,12,4]]}
[null,null," CALCULETTE   version 2.4  du 11/04/2018"]
[]
[null,null,null,"Date :",{"$f":"TODAY()","v":"2018-07-02"}]
[]
["CALCULS SIMPLIFIES DES ÉCHAFAUDAGES FIXES DE FAÇADE A L'EUROCODE"]
[]
["Les calculs ont été réalisés à partir d'un logiciel édité par le Syndicat Français de l'Échafaudage."]
["La méthode de calcul utilisée est une méthode simplifiée adaptée aux chantiers courants à défaut de données du constructeur."]
["Les valeurs des efforts aux ancrages sont indicatives et ont pour objet de faciliter la prédétermination"]
["du type et de la résistance des ancrages."]
["Les résultats sont à comparer aux valeurs (charges ultimes) indiquées par le fabricant de chevilles en fonction du matériau d'accueil."]
["Le nombre d'ancrages ne comprend pas les ancrages supplémentaires à prévoir en périphérie."]
["Ce document ne constitue pas un justificatif de la stabilité de l'échafaudage et de ce fait il ne peut pas être communiqué à des tiers."]
["Il convient de se référer en priorité aux données du constructeur de l'échafaudage."]
["Définition de l'échafaudage"]
[]
["Longueur trame 1",3,"m"]
["Longueur trame 2",3,"m"]
["Largeur échafaudage",1,"m"]
["Hauteur totale échafaudage",5,"m"]
["Hauteur du dernier plancher",4,"m"]
["Nombre total de niveaux de 2.00 m",1]
["Hauteur niveau de départ",2,"m"]
["Nombre de niveaux de console(s)",0]
["Largeur console",null,{"$f":"IF(B25<>\"\",\"m\",\"\")","v":""}]
["Vent"]
[]
["Région de vent",2]
["Échafaudage","non recouvert"]
["Ouvrage","fermé"]
["Coefficient de saison",1]
["Coefficient de probabilité",1]
["Catégorie de terrain","IIIb"]
["Coefficient d'orographie",1.1499999999999999]
["φE",0.25]
["Ct",0.32499999999999984]
["Pression dynamique de pointe",62.57,"daN/m²"]
["Chargement"]
[]
["Altitude du calcul",9,"m"]
["Poids poteau extérieur",40.06,"daN/m linéaire"]
["Poids poteau intérieur",26.61,"daN/m linéaire"]
["Poids console + plateau",null,{"$f":"IF(B43<>\"\",\"daN/niveau\",\"\")","v":""}]
["Classe ",3]
["Charge d'exploitation",200,"daN/m²"]
["Résultats"]
[]
["Descente de charge"]
["Poteau extérieur 1.35 G + 1.5 Q",945.40499999999997,"daN à ELU"]
["Poteau intérieur  1.35 G + 1.5 Q",854.61750000000006,"daN à ELU"]
["Poteau extérieur G + Q",650.29999999999995,"daN à ELS"]
["Poteau intérieur  G + Q",583.04999999999995,"daN à ELS"]
["Efforts dans les ancrages"]
["Effort perpendiculaire à la façade 1.5 W",183.0172499999999,"daN à ELU pour",24,"m²"]
["Effort perpendiculaire à la façade W",122.01149999999994,"daN à ELS pour",24,"m²"]
[]
[]
["VÉRIFIER avec le maître d'œuvre (le donneur d'ordre)"]
["                  - que la résistance des appuis ou de l'ouvrage est compatible avec la descente de charge."]
["                  - que la résistance des ancrages est compatible avec le matériau d'accueil des fixations."]

{"sheet":"Aide","index":2,"n_rows":456,"n_cols":6,"rows_kept":456,"cut":false,"hidden":false,"merged":[[0,0,0,7],[455,0,455,7],[118,0,118,7],[4,0,4,7],[62,0,62,7],[394,0,394,7]]}
["CALCULETTE EUROCODE"]
[]
[]
[]
["ACCUEIL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cliquer sur BONJOUR !",null,"  pour démarrer la calculette.                     "]
[]
[]
[]
[null,"L'action de cliquer sur le bouton BONJOUR ! "]
[]
[null,null,"vous permet d'accéder à la phase CALCULS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PRÉAMBULE"]
[]
[]
["La fenêtre suivante ci-dessous nous demande d’accepter ou non les clauses d’utilisation"]
["de cette calculette."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PHASE CALCULS"]
[]
["Nous arrivons maintenant dans la fenêtre principale de la calculette."]
[]
["A l’ouverture, la fenêtre calcul se présente comme ci-dessous."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nous allons devoir renseigner la première fenêtre appelée définition de l’échafaudage. "]
[]
["Quand nous cliquons sur le "]
["point d’interrogation, on obtient "]
["une fenêtre d’information."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quand nous cliquons sur les boutons option, on obtient la modification des valeurs et des dessins"]
["situés dans la fenêtre en haut à droite."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Lorsque le bouton option Non recouvert est coché, les type 1 et type 2 sont accessibles."]
["Lorsque les boutons option Bâche ou Filet sont cochés, seul le type 2 est accessible."]
[]
["Choisir le type d’ancrage souhaité en cliquant sur le bouton option type 1 ou type 2."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Quand nous cliquons sur le bouton"]
[null,null,null,null,null," dans la fenêtre Région de vent, "]
[null,null,null,null,null,"nous obtenons une fenêtre où"]
[null,null,null,null,null,"apparaissent les différentes régions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Quand nous cliquons sur le bouton"]
[null,null,null,null,null,"dans la fenêtre Coefficient de saison,"]
[null,null,null,null,null,"nous obtenons une fenêtre ou"]
[null,null,null,null,null,"apparaissent les coefficients."]
[null,null,null,null,null,"Relevez la valeur du coefficient."]
[]
[]
[]
[]
[]
[]
[]
["Par défaut, le bouton option > 1 an est coché, soit un coefficient de probabilité de 1 est affiché."]
["Choisir votre durée du chantier."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quand nous cliquons sur le bouton dans la fenêtre Catégories de terrain, on obtient une fenêtre"]
["où apparaissent les différentes catégories."]
["Choisir la catégorie concernée, puis cliquer sur le bouton option correspondant dans la fenêtre"]
["principale."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quand nous cliquons sur le bouton dans la fenêtre Orographie du terrain, on obtient une fenêtre"]
["où apparait une grille permettant de saisir les altitudes nécessaires au calcul."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["La valeur de Coz est de 1.15 par défaut, et ne peut jamais être inférieure à 1."]
[]
[]
[]
["ESTIMATION DE LA DESCENTE DE CHARGE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Saisir les poids propre des composants de l’échafaudage afin d’estimer les descentes de charges."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IMPRESSION DES RÉSULTATS"]

{"sheet":"Sauvegarde","index":3,"n_rows":249,"n_cols":9,"rows_kept":249,"cut":false,"hidden":true,"merged":[]}
["Menu Calculs","Valeur",null,"Orographie","Valeur",null,"Poids Matériel","Valeur"," CALCULETTE   version 2.0  du 17/12/2014"]
["Label94",true,null,"TextBox75","Ae2",null,"TextBox_PlintheTR2","5.86"]
["Label3",true,null,"TextBox69","An2",null,"TextBox_MoiseTR1","11.32"]
["Label7",true,null,"TextBox68","An1",null,"TextBox_MoiseTR2","11.32"]
["OptionButton_region1",false,null,"TextBox67","Ac",null,"TextBox_PlancherTotTR2","58.05"]
["OptionButton_region2",true,null,"TextBox70","As1",null,"TextBox_GcorpsTR1","15.65"]
["OptionButton_region3",false,null,"TextBox71","As2",null,"TextBox_PlancherTotTR1","58.05"]
["OptionButton_region4",false,null,"TextBox72","Ao1",null,"TextBox_GcorpsTR2","15.65"]
["Label16",true,null,"TextBox73","Ao2",null,"TextBox_PlintheTR1","5.86"]
["Label15",true,null,"TextBox74","Ae1",null,"TextBox_PiedARml","40.06"]
["TextBox_vitesse_vent_ms","24",null,"TextBox_Ac",0,null,"TextBox_PiedAVml","26.61"]
["TextBox_vitesse_vent_ms",true,null,"TextBox_An2",0,null,"TextBox_PoidsConsole","0"]
["TextBox_vitesse_vent_ms",true,null,"TextBox_An1",0,null,"TextBox_PlancherTotConsoleTR2","0"]
["Label20",true,null,"TextBox_As1",0,null,"TextBox_PlancherTotConsoleTR1","0"]
["Label25",true,null,"TextBox_As2",0,null,"OptionButton_GC_Avant_oui",false]
["Label32",true,null,"TextBox_Ao1",0,null,"OptionButton_GC_Avant_non",true]
["TextBox15","",null,"TextBox_Ao2",0,null,"TextBox_Ptotal1niveauConsole",""]
["TextBox15",true,null,"TextBox_Ae1",0,null,"TextBox_MoiseTrans","6.56"]
["TextBox15",true,null,"TextBox_Ae2",0,null,"TextBox_Pot200","9.6"]
["TextBox_hauteur_totale","5",null,"TextBox_DeltaAc",0,null,"TextBox_lo","3"]
["TextBox_hauteur_totale",true,null,null,null,null,"TextBox_l1","3"]
["TextBox_hauteur_totale",true,null,null,null,null,"TextBox_Larg_ech","1"]
["OptionButton_nonrecouvert",true,null,null,null,null,"TextBox_LgrConsole","0"]
["OptionButton_bache",false,null,null,null,null,"TextBox_DiagonaleTR2","0"]
["OptionButton_filet",false,null,null,null,null,"TextBox_DiagonaleTR1","10.76"]
["TextBox_cadre_2_image",""]
["TextBox_cadre_2_image",true]
["TextBox_cadre_2_image",true]
["OptionButton_ouvrage_ferme",true]
["OptionButton_ouvrage_ouvert_30",false]
["TextBox_Qpz","62.57"]
["TextBox_Qpz",true]
["TextBox_Qpz",true]
["Label188",true]
["TextBox_duree_du_chantier","1"]
["TextBox_duree_du_chantier",true]
["TextBox_duree_du_chantier",true]
["OptionButton_0",false]
["OptionButton_II",false]
["OptionButton_IIIa",false]
["OptionButton_IIIb",true]
["Label192",true]
["TextBox_Z0","0.5"]
["TextBox_Z0",true]
["TextBox_Z0",true]
["OptionButton_IV",false]
["TextBox_Zmin","9"]
["TextBox_Zmin",true]
["TextBox_Zmin",true]
["Label193",true]
["TextBox14",""]
["TextBox14",true]
["TextBox14",true]
["OptionButton_ouvrage_ouvert_50",false]
["Label196",true]
["TextBox_type_batiment","Bâtiment Fermé"]
["TextBox_type_batiment",true]
["TextBox_type_batiment",true]
["TextBox_Ouvrage",""]
["TextBox_Ouvrage",true]
["TextBox_Ouvrage",true]
["OptionButton_ouvrage_ouvert_plus_5",false]
["TextBox_phib","1"]
["TextBox_phib",true]
["TextBox_phib",true]
["Label_Ouvrage",true]
["Label200",true]
["TextBox_Z_calcul_info","9"]
["TextBox_Z_calcul_info",true]
["TextBox_Z_calcul_info",true]
["Label201",true]
["Label206",true]
["Label207",true]
["TextBox_HtrDernier","4"]
["TextBox_HtrDernier",true]
["TextBox_HtrDernier",true]
["Label209",true]
["TextBox_NbreNivPlanchers200","1"]
["TextBox_NbreNivPlanchers200",true]
["TextBox_NbreNivPlanchers200",true]
["Label210",true]
["Label211",true]
["TextBox_kr","0.223"]
["TextBox_kr",true]
["TextBox_kr",true]
["Label212",true]
["TextBox_Z_calcul","9"]
["TextBox_Z_calcul",true]
["TextBox_Z_calcul",true]
["TextBox_Coz","1.15"]
["TextBox_Coz",true]
["TextBox_Coz",true]
["Label_Coz",true]
["TextBox_PiedAVml","26.61"]
["TextBox_PiedAVml",true]
["TextBox_PiedAVml",true]
["Label149",true]
["Label150",true]
["Label161",true]
["TextBox_PiedARml","40.06"]
["TextBox_PiedARml",true]
["TextBox_PiedARml",true]
["Label162",true]
["Label163",true]
["TextBox_Ptotal1niveauConsole","0"]
["TextBox_Ptotal1niveauConsole",true]
["TextBox_Ptotal1niveauConsole",false]
["Label214",true]
["OptionButton_classe2",false]
["OptionButton_classe3",true]
["OptionButton_classe4",false]
["OptionButton_classe5",false]
["OptionButton_classe6",false]
["Label146",true]
["TextBox_Surcharge","200"]
["TextBox_Surcharge",true]
["TextBox_Surcharge",true]
["Label148",true]
["Label158",true]
["TextBox_ExtnormalELU","945"]
["TextBox_ExtnormalELU",true]
["TextBox_ExtnormalELU",true]
["Label159",true]
["Label215",true]
["Label166",true]
["TextBox_IntnormalELU","855"]
["TextBox_IntnormalELU",true]
["TextBox_IntnormalELU",true]
["TextBox_ExtnormalELS","650"]
["TextBox_ExtnormalELS",true]
["TextBox_ExtnormalELS",true]
["TextBox_IntnormalELS","583"]
["TextBox_IntnormalELS",true]
["TextBox_IntnormalELS",true]
["TextBox_NbreNivConsoles","0"]
["TextBox_NbreNivConsoles",true]
["TextBox_NbreNivConsoles",true]
["Label216",true]
["Label218",true]
["Label219",true]
["TextBox_lo","3"]
["TextBox_lo",true]
["TextBox_lo",true]
["Label220",true]
["Label221",true]
["TextBox_Larg_ech","1"]
["TextBox_Larg_ech",true]
["TextBox_Larg_ech",true]
["TextBox_LgrConsole","0"]
["TextBox_LgrConsole",true]
["TextBox_LgrConsole",false]
["Label222",true]
["Label223",true]
["Label225",true]
["TextBox_EffortAncrageELU","183"]
["TextBox_EffortAncrageELU",true]
["TextBox_EffortAncrageELU",true]
["Label226",true]
["Label233",true]
["Label234",true]
["Label235",true]
["TextBox_l1","3"]
["TextBox_l1",true]
["TextBox_l1",true]
["TextBox_Cs","0.25"]
["TextBox_Cs",true]
["TextBox_Cs",true]
["Label_Cs",true]
["TextBox_Ct","0.325"]
["TextBox_Ct",true]
["TextBox_Ct",true]
["Label_Ct",true]
["OptionButton_Ancrage_type2",false]
["OptionButton_Ancrage_type1",true]
["Label241",true]
["Label242",true]
["TextBox_EffortAncrageELS","122"]
["TextBox_EffortAncrageELS",true]
["TextBox_EffortAncrageELS",true]
["Label224",true]
["TextBox92",""]
["TextBox92",true]
["TextBox92",true]
["Label252",true]
["Label253",true]
["OptionButton_classe1",false]
["TextBox_vitesse_vent_kh","86.4"]
["TextBox_vitesse_vent_kh",true]
["TextBox_vitesse_vent_kh",true]
["Label254",true]
["Label255",true]
["Label256",true]
["Label187",true]
["TextBox_coefficent_de_saison","1"]
["TextBox_coefficent_de_saison",true]
["TextBox_coefficent_de_saison",true]
["TextBox_HtrNiveauDepart","2"]
["TextBox_HtrNiveauDepart",true]
["TextBox_HtrNiveauDepart",true]
["Label258",true]
["Label259",true]
["Label260",true]
["Label264",true]
["Label266",true]
["Label267",true]
["TextBox_SurfaceAncrage","24"]
["TextBox_SurfaceAncrage",true]
["TextBox_SurfaceAncrage",true]
["Label268",true]
["Label269",true]
["Label270",true]
["Label271",true]
["Label272",true]
["Label273",true]
["Label274",true]
["Label_Hauteur",false]
["Label_Charge_explotation",false]
["OptionButton_Csaison_08",false]
["OptionButton_Csaison_09",false]
["OptionButton_Csaison_10",true]
["OptionButton_cprob088",false]
["OptionButton_cprob082",false]
["OptionButton_cprob092",false]
["OptionButton_cprob100",true]
["TextBox_DeltaAc","0"]
["TextBox_DeltaAc",false]
["TextBox_DeltaAc",true]
["Label_DeltaAc",false]
["TextBox_KI_sur_Co","0.92"]
["TextBox_KI_sur_Co",true]
["TextBox_KI_sur_Co",true]
["Label275",true]
["TextBox_Cf","1.3"]
["TextBox_Cf",true]
["TextBox_Cf",true]
["TextBox_Phi_e","0.25"]
["TextBox_Phi_e",true]
["TextBox_Phi_e",true]
["Label_Cf",true]
["Label_Phi_e",true]
["OptionButton_calcul_auto_poids_propre_non",false]
["OptionButton_calcul_auto_poids_propre_oui",true]
["Label276",true]
["Label_verification_poids",false]
["Label_phib",true]
["Label_Ct_filet",false]
["TextBox_Ct_filet","1.3"]
["TextBox_Ct_filet",false]
["TextBox_Ct_filet",true]

{"sheet":"Donnees_DDS","index":4,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8,9,10,11,12,13,14]
[{"$f":"A1+1","v":2},null,null,"Plancher de 0.19 m",0,5.0999999999999996,6.4,8,10.4,12.76,15.6]
[{"$f":"A2+1","v":3},null,null,"Plancher de 0.32 m",0,5.8,8.4,11.6,15,18,21.6]
[4,"Montant",9.6]
[5]
[6,"Largeur",1,{"$f":"C6","v":1},0,0,0.73199999999999998,1.0880000000000001,1.5720000000000001,{"$f":"I6*2","v":3.1440000000000001}]
[7,null,{"$f":"MATCH(HLOOKUP($C$6,$F$6:$I$6,1),$F$6:$I$6)","v":2}]
[8,"U+J",{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A8  & \"C\" & 5+ $C$7,0):INDIRECT(\"L\" & $A8  & \"C\" & 6+ $C$7,0),INDIRECT(\"L\" & $A$6  & \"C\" & 5+ $C$7,0):INDIRECT(\"L\" & $A$6  & \"C\" & 6+ $C$7,0)),2)","v":6.56},0,0,0,{"$f":"2.9+1.24","v":4.1399999999999997},{"$f":"5.5+1.85","v":7.35},{"$f":"8.6+2.6","v":11.2},{"$f":"I8*2","v":22.4}]
[9]
[10,null,{"$f":"MATCH(HLOOKUP($C$11,$F$11:$L$11,1),$F$11:$L$11)","v":6}]
[11,"Longueur trame1",3,0,{"$f":"$C$11","v":3},0,0.73199999999999998,1.0880000000000001,1.5720000000000001,2.0720000000000001,2.5720000000000001,3.0720000000000001,{"$f":"L11*2","v":6.1440000000000001}]
[12,"Longueur trame2",3,0,{"$f":"$C$12","v":3},{"$f":"F11","v":0},0.73199999999999998,1.0880000000000001,1.5720000000000001,2.0720000000000001,2.5720000000000001,3.0720000000000001,{"$f":"L12*2","v":6.1440000000000001}]
[13,null,{"$f":"MATCH(HLOOKUP($C$12,$F$12:$L$12,1),$F$12:$L$12)","v":6}]
[14,"Moise trame 1",{"$f":"ROUNDUP(FORECAST($C$11,INDIRECT(\"L\" & $A14  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A14  & \"C\" & 6+ $C$10,0),INDIRECT(\"L\" & $A$11  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A$11  & \"C\" & 6+ $C$10,0)),2)","v":11.32},0,{"$f":"$C$11","v":3},0,3.9,4.3,6,8,9.6,11.6,{"$f":"L14*2","v":23.2}]
[15,"Moise trame 2",{"$f":"ROUNDUP(FORECAST($C$12,INDIRECT(\"L\" & $A15  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A15  & \"C\" & 6+ $C$13,0),INDIRECT(\"L\" & $A$12  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A$12  & \"C\" & 6+ $C$13,0)),2)","v":11.32},0,{"$f":"$C$12","v":3},{"$f":"F14","v":0},3.9,4.3,6,8,9.6,11.6,{"$f":"L15*2","v":23.2}]
[16]
[17,"GC trame 1",{"$f":"ROUNDUP(FORECAST($C$11,INDIRECT(\"L\" & $A17  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A17  & \"C\" & 6+ $C$10,0),INDIRECT(\"L\" & $A$11  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A$11  & \"C\" & 6+ $C$10,0)),2)","v":15.65},0,{"$f":"$C$11","v":3},0,7.7,8.6999999999999993,9.8000000000000007,11.4,14.7,15.8,{"$f":"L17*2","v":31.6}]
[18,"GC trame 2",{"$f":"ROUNDUP(FORECAST($C$12,INDIRECT(\"L\" & $A18  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A18  & \"C\" & 6+ $C$13,0),INDIRECT(\"L\" & $A$12  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A$12  & \"C\" & 6+ $C$13,0)),2)","v":15.65},0,{"$f":"$C$12","v":3},{"$f":"F17","v":0},7.7,8.6999999999999993,9.8000000000000007,11.4,14.7,15.8,{"$f":"L18*2","v":31.6}]
[19]
[20,"Diagonale trame 1",{"$f":"ROUNDUP(FORECAST($C$11,INDIRECT(\"L\" & $A20  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A20  & \"C\" & 6+ $C$10,0),INDIRECT(\"L\" & $A$11  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A$11  & \"C\" & 6+ $C$10,0)),2)","v":10.76},0,{"$f":"$C$11","v":3},0,7.24,7.55,7.7,8.9,9.1300000000000008,11.03,{"$f":"L20*2","v":22.06}]
[21,"Diagonale trame 2",{"$f":"ROUNDUP(FORECAST($C$12,INDIRECT(\"L\" & $A21  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A21  & \"C\" & 6+ $C$13,0),INDIRECT(\"L\" & $A$12  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A$12  & \"C\" & 6+ $C$13,0)),2)","v":10.76},0,{"$f":"$C$12","v":3},{"$f":"F20","v":0},7.24,7.55,7.7,8.9,9.1300000000000008,11.03,{"$f":"L21*2","v":22.06}]
[22]
[23,"Plinthe trame 1",{"$f":"ROUNDUP(FORECAST($C$11,INDIRECT(\"L\" & $A23  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A23  & \"C\" & 6+ $C$10,0),INDIRECT(\"L\" & $A$11  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A$11  & \"C\" & 6+ $C$10,0)),2)","v":5.8599999999999994},0,{"$f":"$C$11","v":3},0,1,2,3,4,5,6,{"$f":"L23*2","v":12}]
[24,"Plinthe trame 2",{"$f":"ROUNDUP(FORECAST($C$12,INDIRECT(\"L\" & $A24  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A24  & \"C\" & 6+ $C$13,0),INDIRECT(\"L\" & $A$12  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A$12  & \"C\" & 6+ $C$13,0)),2)","v":5.8599999999999994},0,{"$f":"$C$12","v":3},{"$f":"F23","v":0},1,2,3,4,5,6,{"$f":"L24*2","v":12}]
[25]
[26,"Plancher trame 1",{"$f":"ROUNDUP(FORECAST($C$11,INDIRECT(\"L\" & $A26  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A26  & \"C\" & 6+ $C$10,0),INDIRECT(\"L\" & $A$11  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A$11  & \"C\" & 6+ $C$10,0)),2)","v":58.05},{"$f":"D$6","v":1},3,{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & F$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & F$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & G$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & G$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":15.97},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & H$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & H$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":23.130000000000003},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & I$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & I$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":31.94},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & J$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & J$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":41.3},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & K$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & K$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":49.559999999999995},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & L$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & L$1,0),INDIRECT(\"L\" & $A26+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A26+ $C$7+1  & \"C\" & $D$1,0)),2)","v":59.47},{"$f":"L26*2","v":118.94}]
[27,{"$f":"B26","v":"Plancher trame 1"},null,{"$f":"TRANSPOSE(F6:I6)","v":0},3,0,0,0,0,0,0,0,{"$f":"L27*2","v":0}]
[28,{"$f":"B27","v":"Plancher trame 1"},null,0.73199999999999998,3,{"$f":"2*E$3","v":0},11.6,16.8,23.2,30,36,43.2,{"$f":"L28*2","v":86.4}]
[29,{"$f":"B28","v":"Plancher trame 1"},null,1.0880000000000001,3,{"$f":"3*E$3","v":0},17.399999999999999,25.200000000000003,34.799999999999997,45,54,64.800000000000011,{"$f":"L29*2","v":129.60000000000002}]
[30,{"$f":"B29","v":"Plancher trame 1"},null,1.5720000000000001,3,{"$f":"4*E$3+E$2","v":0},28.299999999999997,40,54.4,70.400000000000006,84.76,102,{"$f":"L30*2","v":204}]
[31,null,null,{"$f":"D30*2","v":3.1440000000000001},{"$f":"E30*2","v":6},{"$f":"F30*2","v":0},{"$f":"G30*2","v":56.599999999999994},80,108.8,140.80000000000001,169.52,204]
[32]
[33,"Plancher trame 2",{"$f":"ROUNDUP(FORECAST($C$12,INDIRECT(\"L\" & $A33  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A33  & \"C\" & 6+ $C$13,0),INDIRECT(\"L\" & $A$12  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A$12  & \"C\" & 6+ $C$13,0)),2)","v":58.05},{"$f":"D$6","v":1},{"$f":"$C$12","v":3},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & F$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & F$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & G$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & G$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":15.97},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & H$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & H$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":23.130000000000003},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & I$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & I$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":31.94},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & J$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & J$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":41.3},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & K$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & K$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":49.559999999999995},{"$f":"ROUNDUP(FORECAST($C$6,INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & L$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & L$1,0),INDIRECT(\"L\" & $A33+ $C$7  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A33+ $C$7+1  & \"C\" & $D$1,0)),2)","v":59.47},{"$f":"L33*2","v":118.94}]
[34,{"$f":"B33","v":"Plancher trame 2"},null,{"$f":"D27","v":0},{"$f":"$C$12","v":3},{"$f":"F27","v":0},0,0,0,0,0,0,{"$f":"L34*2","v":0}]
[35,{"$f":"B34","v":"Plancher trame 2"},null,{"$f":"D28","v":0.73199999999999998},{"$f":"$C$12","v":3},0,11.6,16.8,23.2,30,36,43.2,{"$f":"L35*2","v":86.4}]
[36,{"$f":"B35","v":"Plancher trame 2"},null,{"$f":"D29","v":1.0880000000000001},{"$f":"$C$12","v":3},{"$f":"F29","v":0},17.399999999999999,25.200000000000003,34.799999999999997,45,54,64.800000000000011,{"$f":"L36*2","v":129.60000000000002}]
[37,{"$f":"B36","v":"Plancher trame 2"},null,{"$f":"D30","v":1.5720000000000001},{"$f":"$C$12","v":3},{"$f":"F30","v":0},28.299999999999997,40,54.4,70.400000000000006,84.76,102,{"$f":"L37*2","v":204}]
[38,null,null,{"$f":"D37*2","v":3.1440000000000001},{"$f":"E37*2","v":6},{"$f":"F37*2","v":0},56.599999999999994,80,108.8,140.80000000000001,169.52,204]
[39]
[40]
[41,"Largeur console",0,{"$f":"C41","v":0},{"$f":"$C$41","v":0},0,0.28000000000000003,0.39,0.73199999999999998,{"$f":"I41*2","v":1.464}]
[42,null,{"$f":"MATCH(HLOOKUP($C$41,$F$41:$I$41,1),$F$41:$I$41)","v":1}]
[43,"Plancher console  trame 1",{"$f":"ROUNDUP(FORECAST($C$11,INDIRECT(\"L\" & $A43  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A43  & \"C\" & 6+ $C$10,0),INDIRECT(\"L\" & $A$11  & \"C\" & 5+ $C$10,0):INDIRECT(\"L\" & $A$11  & \"C\" & 6+ $C$10,0)),2)","v":0},{"$f":"D$41","v":0},{"$f":"$C$11","v":3},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & F$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & F$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & G$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & G$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & H$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & H$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & I$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & I$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & J$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & J$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & K$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & K$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & L$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & L$1,0),INDIRECT(\"L\" & $A43+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A43+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"L43*2","v":0}]
[44,{"$f":"B43","v":"Plancher console  trame 1"},null,{"$f":"TRANSPOSE(F41:I41)","v":0},{"$f":"$C$11","v":3},0,0,0,0,0,0,0,{"$f":"L44*2","v":0}]
[45,{"$f":"B44","v":"Plancher console  trame 1"},null,0.28000000000000003,{"$f":"$C$11","v":3},{"$f":"E$2","v":0},5.0999999999999996,6.4,8,10.4,12.76,15.6,{"$f":"L45*2","v":31.2}]
[46,{"$f":"B45","v":"Plancher console  trame 1"},null,0.39,{"$f":"$C$11","v":3},{"$f":"E$3","v":0},5.8,8.4,11.6,15,18,21.6,{"$f":"L46*2","v":43.2}]
[47,{"$f":"B46","v":"Plancher console  trame 1"},null,0.73199999999999998,{"$f":"$C$11","v":3},{"$f":"2*E$3","v":0},11.6,16.8,23.2,30,36,43.2,{"$f":"L47*2","v":86.4}]
[48,null,null,{"$f":"D47*2","v":1.464},6,0,23.2,33.6,46.4,60,72,86.4]
[49]
[50,"Plancher console  trame 2",{"$f":"ROUNDUP(FORECAST($C$12,INDIRECT(\"L\" & $A50  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A50  & \"C\" & 6+ $C$13,0),INDIRECT(\"L\" & $A$12  & \"C\" & 5+ $C$13,0):INDIRECT(\"L\" & $A$12  & \"C\" & 6+ $C$13,0)),2)","v":0},{"$f":"D$41","v":0},{"$f":"$C$12","v":3},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & F$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & F$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & G$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & G$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & H$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & H$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & I$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & I$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & J$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & J$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & K$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & K$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"ROUNDUP(FORECAST($C$41,INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & L$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & L$1,0),INDIRECT(\"L\" & $A50+ $C$42  & \"C\" & $D$1,0):INDIRECT(\"L\" & $A50+ $C$42+1  & \"C\" & $D$1,0)),2)","v":0},{"$f":"L50*2","v":0}]
[51,{"$f":"B50","v":"Plancher console  trame 2"},null,{"$f":"D44","v":0},{"$f":"$C$12","v":3},{"$f":"F44","v":0},0,0,0,0,0,0,{"$f":"L51*2","v":0}]
[52,{"$f":"B51","v":"Plancher console  trame 2"},null,{"$f":"D45","v":0.28000000000000003},{"$f":"$C$12","v":3},{"$f":"F45","v":0},5.0999999999999996,6.4,8,10.4,12.76,15.6,{"$f":"L52*2","v":31.2}]
[53,{"$f":"B52","v":"Plancher console  trame 2"},null,{"$f":"D46","v":0.39},{"$f":"$C$12","v":3},{"$f":"F46","v":0},5.8,8.4,11.6,15,18,21.6,{"$f":"L53*2","v":43.2}]
[54,{"$f":"B53","v":"Plancher console  trame 2"},null,{"$f":"D47","v":0.73199999999999998},{"$f":"$C$12","v":3},{"$f":"F47","v":0},11.6,16.8,23.2,30,36,43.2,{"$f":"L54*2","v":86.4}]
[55,null,null,{"$f":"D54*2","v":1.464},6,0,23.2,33.6,46.4,60,72,86.4]
[56]
[{"$f":"A56+1","v":57},"Console+J",{"$f":"ROUND(FORECAST($C$41,INDIRECT(\"L\" & $A57  & \"C\" & 5+ $C$42,0):INDIRECT(\"L\" & $A57  & \"C\" & 6+ $C$42,0),INDIRECT(\"L\" & $A$41  & \"C\" & 5+ $C$42,0):INDIRECT(\"L\" & $A$41  & \"C\" & 6+ $C$42,0)),2)","v":0},0,0,0,3.4,{"$f":"4+0.63","v":4.63},{"$f":"6.4+1.24","v":7.6400000000000006},{"$f":"I57*2","v":15.280000000000001}]